﻿CREATE PROCEDURE [dbo].[proc_Company_GetDwbh]
	(
		@UserName nvarchar(50),
		@CompanyId VARCHAR(MAX) output
	)
AS
	DECLARE @ID INT
	Select @ID=CompanyId from aspnet_Users Where UserName=@UserName
	Select @CompanyId=dwbh FROM Company WHERE Id=@ID
	RETURN @CompanyId
